SUPPORT / SAMPLES & SAS NOTES
Problem Note 53068: "ERROR: The ID value 'DIST_SG_0' occurs twice in the same BY group" might occur when you are using store grouping rules
 |  |  |  |  |
The following error might occur when you attempt to manually create store groups using store grouping rules in SAS® Size Profiling:
ERROR: The ID value "DIST_SG_0" occurs twice in the same BY group. NOTE: The above message was for the following BY group: PROD_LVL=1 PROD_HIER_SK=1 ERROR: The ID value "DIST_SG_0" occurs twice in the same BY group. NOTE: The above message was for the following BY group: PROD_LVL=2 PROD_HIER_SK=4 ...... ERROR: All BY groups were bad. NOTE: The SAS System stopped processing this step because of errors. NOTE: There were 24 observations read from the data set THRD_LIB.TMP_DISTMAP. WARNING: The data set THRD_LIB.TMP_DISTMAP_XPOSE may be incomplete. When this step was stopped there were 0 observations and 0 variables.
There are no workarounds for this issue.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Size Profiling | Microsoft® Windows® for x64 | 3.2_M4 | 3.4 | 9.3 TS1M2 | 9.4 TS1M3 |
| 64-bit Enabled AIX | 3.2_M4 | 3.4 | 9.3 TS1M2 | 9.4 TS1M3 | ||
| Linux for x64 | 3.2_M4 | 3.4 | 9.3 TS1M2 | 9.4 TS1M3 | ||